using System;
using System.Data;
using BeeldBank.Data.Sql;
using System.Data.SqlClient;

namespace BeeldBank.Data
{
	/// <summary>
	/// Provides database independant methods for Type.
	/// </summary>
	public class PrijsInfo : PrijsInfoBase
	{
		public static DataTable GetTypes () {


			return Open( "BEELDBANK_CUSTOM_PRIJSINFO_SELECT_TYPE", null );
		}
		public static DataTable GetTypes (int MediaType) {


			SqlParameter[] sqlParamArray = new SqlParameter[ 1 ];

			sqlParamArray[ 0 ] = new SqlParameter( "@MediaType", SqlDbType.Int );
			sqlParamArray[ 0 ].Value = MediaType;
			return OpenParamArray( "BEELDBANK_CUSTOM_PRIJSINFO_SELECT_TYPE_BY_MEDIATYPE",sqlParamArray, null );
		}
		public static DataTable GetFormats ( int Type ) {

			SqlParameter[] sqlParamArray = new SqlParameter[ 1 ];



			sqlParamArray[ 0 ] = new SqlParameter( "@Type", SqlDbType.Int );
			sqlParamArray[ 0 ].Value = Type;
			

			return OpenParamArray( "BEELDBANK_CUSTOM_PRIJSINFO_SELECT_FORMAAT", sqlParamArray, null );
		}
	

	}
}
